Release 10.1A: OpenEdge Development:
Programming Interfaces

Creating aliases in applications

You cannot assign and reference an alias in the same procedure. You must assign an alias to a logical database name prior to compiling and running procedures that use that alias. For example, i-alias1.p below fails to compile when it reaches the FOR EACH statement, because you cannot assign and reference the alias myalias in a single procedure:

i-alias1.p

/* Note that this procedure does not work */ CREATE ALIAS myalias FOR DATABASE sports. FOR EACH myalias.customer:   DISPLAY customer. END.

To solve this problem, split i-alias1.p into two procedures, as in the following examples:

i-alias2.p

CREATE ALIAS myalias FOR DATABASE sports. RUN i-dispcust.p.

i-dispcust.p

FOR EACH myalias.customer:      /* myalias.customer */   DISPLAY customer.             /* myalias.customer */ END.